| Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
Id |
|
INTEGER |
NO |
|
| Code |
|
CHAR(8) |
NO |
|
| Name |
|
VARCHAR(40) |
NO |
|
| CampusGroupId |
|
INTEGER |
NO |
|
| RoomBoard |
|
MONEY(19, 4) |
YES |
|
| Travel |
|
MONEY(19, 4) |
YES |
|
| OtherDescription1 |
|
VARCHAR(40) |
YES |
|
| OtherAmount1 |
|
MONEY(19, 4) |
YES |
|
| OtherDescription2 |
|
VARCHAR(40) |
YES |
|
| OtherAmount2 |
|
MONEY(19, 4) |
YES |
|
| OtherDescription3 |
|
VARCHAR(40) |
YES |
|
| OtherAmount3 |
|
MONEY(19, 4) |
YES |
|
| OtherDescription4 |
|
VARCHAR(40) |
YES |
|
| OtherAmount4 |
|
MONEY(19, 4) |
YES |
|
| IsActive |
|
BIT |
NO |
|
| LastModifiedUserId |
|
INTEGER |
NO |
|
| CreatedDateTime |
|
DATETIME |
NO |
|
| LastModifiedDateTime |
|
DATETIME |
NO |
|
| RowVersion |
|
TIMESTAMP/DATE |
NO |
|
| Books |
|
MONEY(19, 4) |
YES |
|
| IsOtherCharge1Institutional |
|
BIT |
NO |
|
| IsOtherCharge2Institutional |
|
BIT |
NO |
|
| IsOtherCharge3Institutional |
|
BIT |
NO |
|
| IsOtherCharge4Institutional |
|
BIT |
NO |
|
| Tuition |
|
MONEY(19, 4) |
YES |
|
| InstitutionChargesCalcMethod |
|
CHAR(1) |
YES |
|
| OtherAmount5 |
|
MONEY(19, 4) |
YES |
|
| OtherAmount6 |
|
MONEY(19, 4) |
YES |
|
| OtherAmount7 |
|
MONEY(19, 4) |
YES |
|
| OtherAmount8 |
|
MONEY(19, 4) |
YES |
|
| OtherDescription5 |
|
CHAR(40) |
YES |
|
| OtherDescription6 |
|
CHAR(40) |
YES |
|
| OtherDescription7 |
|
CHAR(40) |
YES |
|
| OtherDescription8 |
|
CHAR(40) |
YES |
|
| IsOtherCharge5Institutional |
|
BIT |
NO |
|
| IsOtherCharge6Institutional |
|
BIT |
NO |
|
| IsOtherCharge7Institutional |
|
BIT |
NO |
|
| IsOtherCharge8Institutional |
|
BIT |
NO |
|
| OffCampusRoomBoard |
|
MONEY(19, 4) |
YES |
|
| OffCampusTravel |
|
MONEY(19, 4) |
YES |
|
| OffCampusOtherDescription1 |
|
VARCHAR(40) |
YES |
|
| OffCampusOtherDescription2 |
|
VARCHAR(40) |
YES |
|
| OffCampusOtherDescription3 |
|
VARCHAR(40) |
YES |
|
| OffCampusOtherDescription4 |
|
VARCHAR(40) |
YES |
|
| OffCampusOtherDescription5 |
|
VARCHAR(40) |
YES |
|
| OffCampusOtherDescription6 |
|
VARCHAR(40) |
YES |
|
| OffCampusOtherDescription7 |
|
VARCHAR(40) |
YES |
|
| OffCampusOtherDescription8 |
|
VARCHAR(40) |
YES |
|
| OffCampusOtherAmount1 |
|
MONEY(19, 4) |
YES |
|
| OffCampusOtherAmount2 |
|
MONEY(19, 4) |
YES |
|
| OffCampusOtherAmount3 |
|
MONEY(19, 4) |
YES |
|
| OffCampusOtherAmount4 |
|
MONEY(19, 4) |
YES |
|
| OffCampusOtherAmount5 |
|
MONEY(19, 4) |
YES |
|
| OffCampusOtherAmount6 |
|
MONEY(19, 4) |
YES |
|
| OffCampusOtherAmount7 |
|
MONEY(19, 4) |
YES |
|
| OffCampusOtherAmount8 |
|
MONEY(19, 4) |
YES |
|
| IsOffCampusOtherCharge1Institutional |
|
BIT |
NO |
|
| IsOffCampusOtherCharge2Institutional |
|
BIT |
NO |
|
| IsOffCampusOtherCharge3Institutional |
|
BIT |
NO |
|
| IsOffCampusOtherCharge4Institutional |
|
BIT |
NO |
|
| IsOffCampusOtherCharge5Institutional |
|
BIT |
NO |
|
| IsOffCampusOtherCharge6Institutional |
|
BIT |
NO |
|
| IsOffCampusOtherCharge7Institutional |
|
BIT |
NO |
|
| IsOffCampusOtherCharge8Institutional |
|
BIT |
NO |
|
| OnCampusRoomBoard |
|
MONEY(19, 4) |
YES |
|
| OnCampusTravel |
|
MONEY(19, 4) |
YES |
|
| OnCampusOtherDescription1 |
|
VARCHAR(40) |
YES |
|
| OnCampusOtherDescription2 |
|
VARCHAR(40) |
YES |
|
| OnCampusOtherDescription3 |
|
VARCHAR(40) |
YES |
|
| OnCampusOtherDescription4 |
|
VARCHAR(40) |
YES |
|
| OnCampusOtherDescription5 |
|
VARCHAR(40) |
YES |
|
| OnCampusOtherDescription6 |
|
VARCHAR(40) |
YES |
|
| OnCampusOtherDescription7 |
|
VARCHAR(40) |
YES |
|
| OnCampusOtherDescription8 |
|
VARCHAR(40) |
YES |
|
| OnCampusOtherAmount1 |
|
MONEY(19, 4) |
YES |
|
| OnCampusOtherAmount2 |
|
MONEY(19, 4) |
YES |
|
| OnCampusOtherAmount3 |
|
MONEY(19, 4) |
YES |
|
| OnCampusOtherAmount4 |
|
MONEY(19, 4) |
YES |
|
| OnCampusOtherAmount5 |
|
MONEY(19, 4) |
YES |
|
| OnCampusOtherAmount6 |
|
MONEY(19, 4) |
YES |
|
| OnCampusOtherAmount7 |
|
MONEY(19, 4) |
YES |
|
| OnCampusOtherAmount8 |
|
MONEY(19, 4) |
YES |
|
| IsOnCampusOtherCharge1Institutional |
|
BIT |
NO |
|
| IsOnCampusOtherCharge2Institutional |
|
BIT |
NO |
|
| IsOnCampusOtherCharge3Institutional |
|
BIT |
NO |
|
| IsOnCampusOtherCharge4Institutional |
|
BIT |
NO |
|
| IsOnCampusOtherCharge5Institutional |
|
BIT |
NO |
|
| IsOnCampusOtherCharge6Institutional |
|
BIT |
NO |
|
| IsOnCampusOtherCharge7Institutional |
|
BIT |
NO |
|
| IsOnCampusOtherCharge8Institutional |
|
BIT |
NO |
|
| IsMonthlyBudget |
|
BIT |
NO |
|